AmApplicant 
EntityType  Dependent 
Logical Entity Name  AmApplicant 
Default Table Name  AmApplicant 
Logical Only  NO 
Definition 
 
Note 
 

AmApplicant Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
SyStudentID(PK)(FK)    INTEGER  NO 
 
SyCampusID(FK)    INTEGER  YES 
 
AdDegreeID(FK)    INTEGER  YES 
 
AdProgramID(FK)    INTEGER  YES 
 
AdProgramVersionID(FK)    INTEGER  YES 
 
StartDate    DATETIME  YES 
 
AmHighSchoolID(FK)    INTEGER  YES 
 
HighSchoolGradMonth    TINYINT  YES 
 
HighSchoolGradYear    INTEGER  YES 
 
AmCollegeID(FK)    INTEGER  YES 
 
DateAdded    DATETIME  NO 
 
DateLstMod    DATETIME  NO 
 
UserID(FK)    INTEGER  NO 
 
ApplicationProgress    INTEGER  YES 
 
ShiftId(FK)    INTEGER  YES 
 
GradeLevelId(FK)    INTEGER  YES 
 
SaCCID(FK)    INTEGER  YES 
 
AppFeeAmount    MONEY(19, 4)  YES 
 
ts    TIMESTAMP/DATE  NO 
 
Id(FK)    INTEGER  YES 
 

AmApplicant Keys 
Key Name  Key Type  Keys 
AmApplicant_AdProgramID_N_N_IDX  Inversion Entry  AdProgramID 
AmApplicant_AdGradeLevelID_N_N_IDX  Inversion Entry  GradeLevelId 
AmApplicant_AdDegreeID_N_N_IDX  Inversion Entry  AdDegreeID 
AmApplicant_UserID_N_N_IDX  Inversion Entry  UserID 
AmApplicant_SyCampusID_N_N_IDX  Inversion Entry  SyCampusID 
AmApplicant_SyStudentID_U_C_IDX  PrimaryKey  SyStudentID 
AmApplicant_AmHighSchoolID_N_N_IDX  Inversion Entry  AmHighSchoolID 
AmApplicant_AmCollegeID_N_N_IDX  Inversion Entry  AmCollegeID 
AmApplicant_AdProgramVersionID_N_N_IDX  Inversion Entry  AdProgramVersionID 
AmApplicant_SaCCID_N_N_IDX  Inversion Entry  SaCCID 
AmApplicant_AdStartDateID_N_N_IDX  Inversion Entry  ShiftId 

AmApplicant Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Degree  Non-Identifying  Zero or One to Zero or More        AdDegreeID  NO 
GradeLevel  Non-Identifying  Zero or One to Zero or More        GradeLevelId  NO 
Program  Non-Identifying  Zero or One to Zero or More        AdProgramID  NO 
ProgramVersion  Non-Identifying  Zero or One to Zero or More        AdProgramVersionID  NO 
SchoolStartDate  Non-Identifying  Zero or One to Zero or More        ShiftId, Id  NO 
College  Non-Identifying  Zero or One to Zero or More        AmCollegeID  NO 
HighSchool  Non-Identifying  Zero or One to Zero or More        AmHighSchoolID  NO 
StudentCreditCard  Non-Identifying  Zero or One to Zero or More        SaCCID  NO 
Campus  Non-Identifying  Zero or One to Zero or More        SyCampusID  NO 
Student  Identifying  One To Zero or More        SyStudentID  NO 
Staff  Non-Identifying  One To Zero or More        UserID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

AmApplicant Check Constraints 
Check Constraint Name  CheckConstraint